Tabela OrgUnitPlainHierarchy

Definicja tabeli OrgUnitPlainHierarchy

Name

OrgUnitPlainHierarchy

Code

OrgUnitPlainHierarchy

Comment

 


Lista kolumn tabeli OrgUnitPlainHierarchy

Name

Code

OrgUnitID

OrgUnitID

HierarchyType205

HierarchyType205

HierarchyType201

HierarchyType201

HierarchyType200

HierarchyType200

HierarchyType197

HierarchyType197

HierarchyType162

HierarchyType162

HierarchyType69

HierarchyType69

HierarchyType49

HierarchyType49

HierarchyType40

HierarchyType40

HierarchyType20

HierarchyType20

HierarchyType18

HierarchyType18

HierarchyType17

HierarchyType17

HierarchyType8

HierarchyType8

HierarchyType3

HierarchyType3

HierarchyType2

HierarchyType2

HierarchyType1

HierarchyType1

RegisterBookHealtCareID

RegisterBookHealtCareID

RegisterBookOrgUnitID

RegisterBookOrgUnitID

RegisterBookDivisionID

RegisterBookDivisionID

RegisterBookCompanyBranchID

RegisterBookCompanyBranchID

HierarchyType4

HierarchyType4

HierarchyType5

HierarchyType5

HierarchyType301

HierarchyType301

HierarchyType300

HierarchyType300

HierarchyType70

HierarchyType70


Kolumna OrgUnitID tabeli OrgUnitPlainHierarchy

Definicja kolumny OrgUnitID tabeli OrgUnitPlainHierarchy

Name

OrgUnitID

Code

OrgUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HierarchyType205 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType205 tabeli OrgUnitPlainHierarchy

Name

HierarchyType205

Code

HierarchyType205

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType201 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType201 tabeli OrgUnitPlainHierarchy

Name

HierarchyType201

Code

HierarchyType201

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType200 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType200 tabeli OrgUnitPlainHierarchy

Name

HierarchyType200

Code

HierarchyType200

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType197 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType197 tabeli OrgUnitPlainHierarchy

Name

HierarchyType197

Code

HierarchyType197

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType162 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType162 tabeli OrgUnitPlainHierarchy

Name

HierarchyType162

Code

HierarchyType162

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType69 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType69 tabeli OrgUnitPlainHierarchy

Name

HierarchyType69

Code

HierarchyType69

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType49 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType49 tabeli OrgUnitPlainHierarchy

Name

HierarchyType49

Code

HierarchyType49

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType40 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType40 tabeli OrgUnitPlainHierarchy

Name

HierarchyType40

Code

HierarchyType40

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType20 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType20 tabeli OrgUnitPlainHierarchy

Name

HierarchyType20

Code

HierarchyType20

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType18 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType18 tabeli OrgUnitPlainHierarchy

Name

HierarchyType18

Code

HierarchyType18

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType17 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType17 tabeli OrgUnitPlainHierarchy

Name

HierarchyType17

Code

HierarchyType17

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType8 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType8 tabeli OrgUnitPlainHierarchy

Name

HierarchyType8

Code

HierarchyType8

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType3 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType3 tabeli OrgUnitPlainHierarchy

Name

HierarchyType3

Code

HierarchyType3

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType2 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType2 tabeli OrgUnitPlainHierarchy

Name

HierarchyType2

Code

HierarchyType2

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HierarchyType1 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType1 tabeli OrgUnitPlainHierarchy

Name

HierarchyType1

Code

HierarchyType1

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RegisterBookHealtCareID tabeli OrgUnitPlainHierarchy

Definicja kolumny RegisterBookHealtCareID tabeli OrgUnitPlainHierarchy

Name

RegisterBookHealtCareID

Code

RegisterBookHealtCareID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RegisterBookOrgUnitID tabeli OrgUnitPlainHierarchy

Definicja kolumny RegisterBookOrgUnitID tabeli OrgUnitPlainHierarchy

Name

RegisterBookOrgUnitID

Code

RegisterBookOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RegisterBookDivisionID tabeli OrgUnitPlainHierarchy

Definicja kolumny RegisterBookDivisionID tabeli OrgUnitPlainHierarchy

Name

RegisterBookDivisionID

Code

RegisterBookDivisionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna RegisterBookCompanyBranchID tabeli OrgUnitPlainHierarchy

Definicja kolumny RegisterBookCompanyBranchID tabeli OrgUnitPlainHierarchy

Name

RegisterBookCompanyBranchID

Code

RegisterBookCompanyBranchID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator jednostki, która jest przedsiebiorstwem(wedlug oznaczenia


Kolumna HierarchyType4 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType4 tabeli OrgUnitPlainHierarchy

Name

HierarchyType4

Code

HierarchyType4

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator jednostki, która jest podmiotem (wedlug hierarchii)


Kolumna HierarchyType5 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType5 tabeli OrgUnitPlainHierarchy

Name

HierarchyType5

Code

HierarchyType5

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator jednostki, która jest przedsiebiorstwem (wedlug hierarchii)


Kolumna HierarchyType301 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType301 tabeli OrgUnitPlainHierarchy

Name

HierarchyType301

Code

HierarchyType301

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator jednostki, która jest Apteka (wedlug hierarchii)


Kolumna HierarchyType300 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType300 tabeli OrgUnitPlainHierarchy

Name

HierarchyType300

Code

HierarchyType300

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator jednostki, która jest Prosektorium (wedlug hierarchii)


Kolumna HierarchyType70 tabeli OrgUnitPlainHierarchy

Definicja kolumny HierarchyType70 tabeli OrgUnitPlainHierarchy

Name

HierarchyType70

Code

HierarchyType70

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator jednostki o typie stanowisko lózkowe


Lista kluczy tabeli OrgUnitPlainHierarchy

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OrgUnitPlainHierarchy

Definicja klucza Identifier_1 tabeli OrgUnitPlainHierarchy

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment